SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002631s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 347529 LIMIT 1 [ RunTime:0.000430s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 347529 [ RunTime:0.001731s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (416326,72231,672492,928854,225804,509428,1015774,588413,905717,289188,1035299,880062,205407,537367,364709,639035,703677,564056,732445,936408,426432,482200,178679,1039439,185319,533761,429119,320334,124769,197627,88825,602962,99056,820758,654168,95623,671561,200020,61500,721998,844673,337395,381378,397991,510512,124615,726966,330086,132139,533419,973235,84582,261825,957017,1016820,927750,339721,102569,550389,778663) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 347529 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 347529 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000468s ]