SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1006713 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1006713 [ RunTime:0.002130s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (42373,730863,1018067,343748,895772,808526,107,218150,850249,593439,835799,89961,726159,805390,1029937,293871,40123,187390,499280,507441,674588,14579,203113,959701,545534,126450,249539,346518,404279,449180,723864,587871,449836,320391,751554,355721,190665,1019639,252433,251250,484902,815310,874192,683869,728072,995918,65531,1001290,653659,236654,666191,34911,796588,181743,235107,406947,69839,719498,147770,107372) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1006713 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1006713 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000559s ]