SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 242013 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 242013 [ RunTime:0.001342s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (189284,642661,86448,958542,615227,956179,752502,946677,69699,507673,821618,946473,44807,22995,131045,666192,686211,147582,414136,329112,441207,816723,639221,438724,66344,385173,108054,188727,961879,447319,491362,815657,4866,247977,330067,324781,220236,71536,1005571,652322,749940,455417,938012,1004712,54569,481868,793913,326506,506737,334484,152161,761397,202385,61221,704750,237910,591090,15338,720150,389697) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001008s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 242013 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 242013 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]