SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001233s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401110 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401110 [ RunTime:0.003257s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (84070,508548,347826,210657,607628,328674,40902,252817,311284,975276,491711,852253,826881,375208,336456,1045827,581437,180672,691453,926347,784300,88013,413299,457931,480520,336100,741044,135508,453975,88217,727510,710228,480831,325294,7194,133272,138288,179230,268193,1016159,300915,86215,886359,1022199,545345,836675,973345,86486,885326,748572,407726,44270,420545,174838,68749,19955,908773,459828,60131,171022) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401110 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401110 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001111s ]