SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503646 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503646 [ RunTime:0.002351s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (599967,156922,1016173,19904,613054,589290,496799,109176,909961,663485,714761,896058,716346,115601,111173,728981,581377,331839,925932,218840,273358,880303,649119,372563,242979,200630,238625,818671,1048387,633466,243119,505244,211646,570709,369887,605638,235691,329591,461957,509476,343510,670827,30985,258439,115272,546630,668177,233435,56153,290407,74858,454702,709298,897896,804413,443449,950304,133185,944177,879841) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001076s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503646 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503646 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000756s ]