SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 514033 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514033 [ RunTime:0.001855s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (436107,743693,955113,87245,88382,182824,827784,55974,528140,445765,353047,93370,810181,1043607,481281,42725,284502,155877,708956,239413,772263,108156,161937,217828,436391,398562,610352,720026,873773,444330,590700,626822,639980,162709,547933,34869,25551,510463,197523,777135,569999,229463,727045,311884,257361,534393,27240,787273,1034825,227969,870809,80930,40039,594373,717132,633373,130393,622833,79123,196733) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000953s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514033 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514033 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000448s ]