SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003439s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1039103 LIMIT 1 [ RunTime:0.003167s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1039103 [ RunTime:0.002522s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (836187,56672,860454,501656,79402,174756,148281,66702,870178,903300,1033893,972491,805730,691685,460712,176421,610133,1002153,78655,86858,313258,671872,475587,915169,221053,157537,738527,941206,250897,893364,720111,63443,612801,844479,913661,715494,453679,719350,890001,3873,741346,72564,935029,31012,600299,524933,634049,575633,727007,255344,707755,439260,834205,406681,275182,292007,733583,945915,672667,734528) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001267s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1039103 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001685s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1039103 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000694s ]