SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001299s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 412873 LIMIT 1 [ RunTime:0.000430s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 412873 [ RunTime:0.007406s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (131997,561811,852476,138019,593501,94589,151398,60411,947818,322693,879866,52231,350668,363985,1041859,814019,503466,476756,604491,298319,888736,98231,475111,236128,378940,154555,527472,907267,757710,122772,810268,341149,389895,130273,226437,586184,308356,377131,243755,936738,142671,791590,990936,432157,778339,195282,984700,691592,318983,390046,868767,946285,253077,826821,549390,385291,441810,357932,625826,200904) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 412873 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000488s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 412873 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000440s ]