SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 526530 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 526530 [ RunTime:0.001607s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (738321,992912,631135,768028,874057,997781,972672,678839,590663,2209,524715,20313,215514,532660,639464,668448,17768,425673,975646,1036217,133598,268539,364071,232803,373156,1027266,92534,519765,939927,530727,838297,507612,581989,280659,1006129,460365,427253,635136,651533,629225,280656,471721,820902,874443,284308,46460,877139,29084,135117,1025437,124219,998559,268098,585073,650488,1040773,994562,883292,844267,797428) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 526530 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000457s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 526530 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000688s ]