SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001243s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 524028 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 524028 [ RunTime:0.002008s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (379019,813742,592029,61282,672218,978998,328106,613395,202744,956564,727830,44407,220759,443243,541886,1017686,400576,948977,399847,361755,336132,705094,890205,646824,519149,284829,871029,498291,145389,280481,617152,585869,134483,160931,97412,784637,301232,436220,836678,767144,347826,710570,606998,499325,516117,453764,826787,527433,317672,476900,274464,946838,153516,802895,486683,944604,775064,145347,488709,326031) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001098s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 524028 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 524028 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000543s ]