SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001296s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 566051 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 566051 [ RunTime:0.001681s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (543297,185294,994943,401525,743012,753036,480644,371316,415340,768120,413632,563797,559741,312727,526609,996218,1039625,524601,16231,1018351,380623,122297,1027768,114070,671008,406346,562008,485265,854095,201716,546187,673256,191621,491740,1040045,310512,654288,594534,220529,807881,30465,386846,428824,961018,349800,667346,118443,1036297,353328,594525,886481,548444,732671,9508,74444,83299,87262,431865,304406,25557) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001041s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 566051 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 566051 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000557s ]