SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001183s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 440073 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 440073 [ RunTime:0.001868s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (747246,592658,598107,703633,62244,189996,488050,426145,658422,1024619,413185,826933,402247,561321,166384,329470,1019810,501007,264921,426267,452364,368858,103417,83521,75970,5207,506184,869216,659637,163133,509011,256897,593604,788715,567729,371941,647997,377973,499079,360035,255468,944653,296542,1002217,595917,631458,318707,545144,767671,34205,849204,100084,748244,730144,149350,641495,371327,32360,47286,212940) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 440073 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 440073 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000409s ]