SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 457361 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 457361 [ RunTime:0.002345s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1020507,61543,439695,150987,135873,463546,866842,738616,471805,911001,600388,467000,688045,149489,148329,476400,892927,701695,69847,289042,426929,855405,311198,777453,620650,5593,365124,553358,278988,589009,545906,550092,798533,20737,670287,54176,130933,409286,232143,728742,625298,197353,556628,752749,577981,440379,145776,465070,580351,1038645,193685,101390,997771,978911,807670,472226,843633,509333,68410,500275) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000967s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 457361 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 457361 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000601s ]