SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001452s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 5683 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 5683 [ RunTime:0.001696s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (822281,889309,89523,974141,785732,603761,119498,146663,248342,305348,1008003,709912,1026125,901632,386976,195989,129793,485507,516522,375853,421329,57227,1000692,1026050,597572,931056,48005,374986,664638,100896,247872,478956,920104,300293,577481,976552,884816,16834,263267,76390,780258,575698,566664,531100,688594,776779,299061,734191,362542,600773,697639,320995,745992,579603,414652,913408,965794,985240,723778,396842) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000990s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 5683 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 5683 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001314s ]