SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002552s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 440012 LIMIT 1 [ RunTime:0.000638s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 440012 [ RunTime:0.003747s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (331494,817482,275657,627514,680742,931381,1047703,328222,1019847,666931,179238,907259,626483,481274,732735,175298,486613,684781,488300,830871,486540,748042,280220,959896,584512,780310,420289,511355,352830,602977,913952,459512,508700,807979,824518,224575,451437,601372,81292,715466,617331,130530,713537,646196,695278,543758,117672,223036,59441,226823,136753,257820,735318,41291,284087,767794,748741,873098,537866,445588) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001687s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 440012 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 440012 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002194s ]