SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001316s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 863541 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 863541 [ RunTime:0.002130s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (539810,372542,1014634,868667,174053,247722,361867,87964,486562,612525,821585,420249,414334,468105,145543,809601,860741,558472,996795,483445,529614,403656,481236,757091,609142,936578,71391,70858,454580,17032,103037,503758,717996,732463,41810,391684,360623,696731,1047784,441887,403091,430424,969794,180929,510184,289342,681234,218489,357264,564398,197108,363427,438796,140876,1007137,235609,62169,247315,994692,925668) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001059s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 863541 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001073s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 863541 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]