SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1018543 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1018543 [ RunTime:0.001824s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (596603,368204,658898,404322,950445,934340,464221,492867,536414,466592,633997,180212,954267,491227,841315,393997,806636,1038693,100155,356736,939389,322081,412100,253310,208635,712068,448793,453277,977389,762906,342576,504082,348641,625070,838682,588308,469280,62453,1003121,905939,161533,639362,164361,739018,609494,769289,5916,111331,708458,32697,617309,556776,166463,301101,149781,80490,104018,995149,810827,684049) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001054s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1018543 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1018543 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003215s ]