SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001272s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 573528 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 573528 [ RunTime:0.001504s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (335206,646409,772106,1023854,22899,538750,808541,489897,719179,347841,981832,400445,296770,1009356,640566,323798,809088,436338,1020303,38978,437286,301217,155122,1016346,934649,381862,145601,544181,1040609,784309,125447,631717,98032,343058,755284,547880,256200,78539,191545,739857,693729,206705,190742,262741,591247,417541,570344,143766,753958,183939,743919,620643,746296,930272,451876,843255,805770,64075,129294,697352) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001000s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 573528 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 573528 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000558s ]