SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 267696 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 267696 [ RunTime:0.001572s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (43406,67678,16966,939252,596871,817705,38154,75406,140433,758445,680263,127507,495771,798329,546837,398628,835862,332692,114086,421328,1022534,733929,628398,767404,344318,656810,163119,1039260,664763,326312,4561,73877,919729,890244,548527,853360,521545,349970,237633,461578,997011,529109,790968,438552,105550,737698,200817,79359,613963,618864,466448,965568,484122,192757,983130,128024,523988,436284,887354,879019) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 267696 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 267696 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000560s ]