SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 145811 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 145811 [ RunTime:0.001597s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (235190,384471,608063,108120,228208,453641,13023,392778,948426,214907,559176,611677,360059,375606,1021495,846579,509640,504551,296807,681132,1039178,548386,171362,276066,539441,52971,934333,284011,216422,973087,846449,898120,812836,254593,382922,456016,216958,484956,1045359,102949,743231,379222,759590,621861,816831,101864,381454,296665,435746,601274,855906,102946,672792,56179,434086,857972,687093,702202,292846,821660) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 145811 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 145811 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000462s ]