SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506954 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506954 [ RunTime:0.005896s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1040594,693176,938500,454998,889029,992239,928155,165744,639849,891382,406672,419166,882953,388699,969406,116608,263072,224768,75397,681868,814628,781185,706854,280941,939307,815277,804832,859820,159818,340345,924545,548412,221668,234795,23916,150287,347131,362737,970721,447218,463122,1025759,7458,1000599,728010,692637,983207,811561,711918,726816,893030,996520,101987,56564,612336,492327,850238,470630,217101,169164) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001465s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506954 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506954 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000779s ]