SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001315s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 270910 LIMIT 1 [ RunTime:0.000615s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 270910 [ RunTime:0.001573s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (567950,429337,331724,224765,408861,639970,304425,928005,773907,896074,1032071,190746,612388,408181,93026,883944,1002759,542051,610833,246428,723028,227300,794787,692342,708702,151656,578230,813725,815619,463443,44290,129601,1007239,780822,819591,938487,594999,60223,722332,739807,785421,1007969,504670,768312,302942,588395,1013643,531167,938881,752802,47326,492751,464227,1037306,450725,74004,572420,988291,430171,107359) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001029s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 270910 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 270910 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]