SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001491s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 51967 LIMIT 1 [ RunTime:0.000578s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 51967 [ RunTime:0.001810s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (987609,724533,955970,701634,696286,815066,38696,909178,907627,494917,1028038,240514,983432,286729,832975,680326,497529,964509,315259,1015709,219574,138028,956210,195737,429483,1008153,703524,976305,834206,245117,797254,862262,379763,504621,223697,649588,853504,731392,326805,325002,421720,1028637,352847,343325,633735,70730,540718,949382,324156,888659,122038,135761,1025595,427069,523811,55574,845869,717013,974515,481210) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002296s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 51967 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 51967 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]