SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1001927 LIMIT 1 [ RunTime:0.002481s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1001927 [ RunTime:0.002029s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (47068,46438,104693,277989,675416,711804,530138,445017,298033,910796,429214,796278,909335,925503,117983,522103,775513,399916,444720,871052,433224,838322,776376,415544,748851,511610,1001449,1939,916749,9460,225249,502394,934443,105019,534485,720346,721363,497021,766080,545544,408825,636925,499614,29453,114500,1002204,848974,183481,542377,59062,860300,240015,742137,210594,611993,101402,578084,351067,514438,238588) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001046s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1001927 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1001927 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000450s ]