SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502152 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502152 [ RunTime:0.002566s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (376504,692870,313228,396566,460092,513889,451369,288203,275444,441646,470073,692604,396399,522063,270171,412236,406473,68456,380175,948567,12707,6131,113392,950605,777854,12142,899635,251011,481830,684833,811891,817138,909757,502230,739729,522735,1994,544194,654434,819903,29090,101455,490344,754157,616126,71659,169336,304927,1016549,576452,503980,407121,313364,33209,379765,690956,683277,111715,484209,37305) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001035s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502152 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502152 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000586s ]