SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 536712 LIMIT 1 [ RunTime:0.001614s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 536712 [ RunTime:0.001954s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (66288,902903,600635,678762,934566,407145,957009,223814,157819,554049,844039,161604,854279,702592,306475,241437,244781,225917,128248,419156,247757,915776,716462,480362,624970,461128,139023,903218,407755,894218,674854,581372,245269,1048802,108110,319139,71037,1029549,66317,740974,437956,509224,254171,52045,722282,952235,301357,963851,57012,558721,398552,636271,518017,611606,603666,1017281,1008365,95767,126110,675528) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000989s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 536712 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 536712 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000559s ]