SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 334590 LIMIT 1 [ RunTime:0.000474s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 334590 [ RunTime:0.005607s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (631360,1019387,416624,762681,781946,374289,485537,441669,746176,639129,627469,293748,945485,510321,583410,331074,129143,543546,590741,1027517,924087,157466,107064,723572,524467,733257,72342,650278,347652,115247,139754,334027,265492,648075,941197,501695,848738,280142,158055,1035659,56825,609653,869279,80509,111138,614147,677372,864568,814189,6406,973326,483404,918681,697776,427593,106252,837902,279801,146170,316663) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 334590 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000446s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 334590 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001389s ]