SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 308010 LIMIT 1 [ RunTime:0.000389s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 308010 [ RunTime:0.001807s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (453730,641632,581579,186076,982880,620499,325530,293400,597211,772818,64777,325068,755935,283287,397288,727161,454281,750458,910204,243863,302000,266906,408475,6128,866219,787602,689061,980933,823928,359055,850231,751679,802982,429185,306819,618949,1009650,757249,712623,1032777,425812,874376,509659,136622,637542,269448,805432,403618,468234,163107,996863,227937,188803,767458,200402,818203,526040,993427,241555,873190) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005663s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 308010 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000425s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 308010 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001266s ]