SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001693s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 48588 LIMIT 1 [ RunTime:0.000760s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 48588 [ RunTime:0.002298s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1240,149947,326211,716001,698540,847307,199333,793410,841447,789022,331898,344886,950497,159971,96069,1044026,789678,31026,346669,19001,126144,239020,311929,806688,510180,678454,199432,482517,477540,428845,220852,26140,590465,481769,733638,82238,582480,849896,848418,353468,647892,853842,204077,1039760,802700,1002738,1006579,391684,44442,517554,552571,954594,132781,303415,244106,8260,913884,144928,461846,125133) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 48588 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002191s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 48588 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000506s ]