SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001291s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534048 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534048 [ RunTime:0.001703s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (551987,730486,765420,644290,925781,97675,93560,109634,875806,336289,98762,893137,388096,769552,608484,877395,569023,207025,828258,144224,964697,320830,385469,3227,795420,388305,849625,638478,517171,573493,940007,772684,267026,225183,157819,949766,593703,471990,970311,288633,229061,761200,610573,794109,571036,881336,513416,895688,732258,394212,588536,379259,1039042,504403,754390,267550,94766,800831,887750,683369) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001987s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534048 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534048 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]