SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 367570 LIMIT 1 [ RunTime:0.000291s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 367570 [ RunTime:0.001479s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (317183,207538,364725,454473,262721,318914,73879,1038004,685752,391098,511641,35208,146807,191582,953381,815482,737897,258688,783089,812218,19035,208545,199752,562760,36754,902693,711420,844413,597568,291909,776678,177481,497618,598397,24673,1043860,848182,978479,397795,514264,926579,90543,630441,1041522,609867,46296,117175,853871,356217,343141,384510,395517,439745,508755,383281,134368,293336,93922,372998,1003380) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 367570 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 367570 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000510s ]