SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 809548 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 809548 [ RunTime:0.002861s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (160178,935488,974403,910570,635221,937453,558027,849443,64977,317060,570372,635592,189454,922412,847288,21027,1043390,610985,610128,667589,441137,317584,1027650,498328,32965,953797,206451,456819,287401,171329,869862,938215,207517,335048,303037,188560,720509,155838,134861,453523,986257,193399,409389,942424,105860,60923,498572,381862,256652,894470,418486,214027,259240,801417,27043,607624,1002559,741582,490516,287533) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 809548 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 809548 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001680s ]