SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002328s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 300417 LIMIT 1 [ RunTime:0.000729s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 300417 [ RunTime:0.001718s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (808779,393225,302903,50874,567366,205562,414037,33176,257015,194163,920260,1014239,790804,386410,139071,246030,650882,143398,219711,489013,892639,160978,834750,289921,382479,385360,794386,450412,495679,543102,530648,884480,846512,356237,629411,622720,175267,534349,746930,20480,902105,809298,360900,380213,770517,594535,587138,747693,552228,482876,298833,15792,72310,24605,8072,32103,428734,524375,539412,1045421) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001267s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 300417 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000763s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 300417 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000528s ]