SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005286s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017239 LIMIT 1 [ RunTime:0.000516s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017239 [ RunTime:0.001550s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1045327,110170,143851,415801,386235,1020059,26562,123689,63570,70572,98234,388878,895266,942293,111936,1035016,754120,410735,870166,245235,172893,910260,621147,216439,277487,843010,533701,816119,476588,563787,956733,225588,150408,1048313,251223,680886,809654,899768,717730,42837,1037160,325510,851461,585306,717592,1042604,709708,775567,602268,416042,756146,520901,717121,564233,765914,87429,362253,623166,901219,68689) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003515s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017239 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017239 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000647s ]