SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 354400 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 354400 [ RunTime:0.004503s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (971221,509283,171851,548886,705290,746163,858472,1039383,576345,426572,696372,966887,859713,229614,179715,551418,1039525,134269,852853,621544,532839,90103,223270,6263,75426,104192,137354,361495,764612,933186,106686,793415,409519,802804,835054,62799,439411,661056,147678,488233,1039203,810546,647439,226337,459394,591799,1016826,407700,318617,299396,917501,354387,426012,314145,713028,514182,601908,171202,229144,957244) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001577s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 354400 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000439s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 354400 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000534s ]