SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001385s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1036573 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1036573 [ RunTime:0.002422s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (309000,620299,854662,90567,949052,1015384,469171,210519,144192,38339,240490,1015436,474082,951123,489921,848170,943941,305715,338153,617760,577817,348829,524705,381955,388608,477700,299210,540037,109323,953621,394191,799457,371505,892797,246839,217348,120571,40030,210530,571884,888402,722074,242802,165497,304797,667898,768543,1044248,597449,600295,1008165,777201,161474,261914,833147,591934,867795,639205,537160,800960) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003653s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1036573 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000555s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1036573 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002851s ]