SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001254s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 599883 LIMIT 1 [ RunTime:0.000435s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 599883 [ RunTime:0.003204s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (621166,1046198,656287,280304,854110,226618,371110,934405,588171,46282,830340,718920,377436,39260,942059,446150,835989,578596,132834,628927,139160,96590,319435,31617,983921,415381,462102,112603,267809,415466,296215,302914,877054,1023143,232878,155802,614415,216506,22830,692265,708155,585559,680574,920290,299851,64252,33561,730052,715475,116349,934560,558710,333339,636926,143840,955040,718402,48105,934714,271353) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003318s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 599883 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 599883 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001729s ]