SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 671530 LIMIT 1 [ RunTime:0.000454s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 671530 [ RunTime:0.003905s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (93129,860877,1022961,864841,284768,1045739,41249,283835,657036,499000,1013104,521968,331771,925939,1003959,466076,230317,955864,467700,253836,400199,148992,897924,326338,889320,1020149,435938,920779,229228,906733,1022681,256677,261782,272017,101305,654615,413276,104779,235703,147,370725,394314,80068,184584,774628,88198,448167,902076,326784,556243,597911,382232,779593,549363,290713,529903,581184,271400,291792,394521) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 671530 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000552s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 671530 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000558s ]