SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 204471 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 204471 [ RunTime:0.001521s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (509350,549901,80763,1010691,366520,444278,13478,413314,280103,931226,618044,314043,264485,498694,469578,501788,509914,232220,788687,136607,834268,509366,941308,28106,594466,971395,1022777,146367,63664,103693,739714,347884,19967,258494,287461,749036,787788,137204,437610,35412,669576,633100,656825,71994,850278,215300,119054,722587,444290,309401,366532,85170,256434,111292,256195,837497,774389,688255,645993,140175) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 204471 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 204471 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000407s ]