SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401578 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401578 [ RunTime:0.002898s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (763411,734086,385970,532764,1006489,412179,1011046,798732,1004221,984584,407368,476940,316731,1003970,521336,939712,181030,302663,736754,48696,613239,102358,748302,433624,855460,659337,642191,330127,23914,968096,950898,323459,9216,258296,734811,506817,765716,720551,847163,756382,194278,386606,558883,952448,628345,220941,734465,936333,71837,944489,39887,174117,684080,541463,766756,656644,564147,121503,520603,747077) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001043s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401578 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000461s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401578 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001076s ]