SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 449380 LIMIT 1 [ RunTime:0.000962s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 449380 [ RunTime:0.002554s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (516631,445078,586395,564270,115434,522231,217589,596569,3225,830765,338374,966956,1001567,957333,350628,316345,913629,692298,599192,153215,768542,997885,817412,446702,688624,977967,805051,121204,164726,217064,954622,736289,471252,443995,953219,395352,224049,354763,430524,227226,64016,626825,890958,62672,300890,505067,1027054,251229,301213,562156,856752,777638,432193,416932,262544,234424,480198,198619,511337,904940) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003819s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 449380 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 449380 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001089s ]