SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012681 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012681 [ RunTime:0.001591s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (758232,514417,11973,217579,116406,535999,549638,599139,85204,991339,394068,621058,220118,222092,846549,73531,498867,460935,290332,843390,498558,1046666,518293,175536,567132,98100,283276,677944,731244,195492,231108,275017,680812,385368,382188,470768,115035,419627,834183,88347,724793,729346,969365,184068,490595,334208,154090,171285,628280,429576,240026,426948,501340,177350,1011160,907513,411288,108088,687538,118968) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012681 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012681 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000463s ]