SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 497601 LIMIT 1 [ RunTime:0.004980s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 497601 [ RunTime:0.001474s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (58689,816910,51762,720834,789736,472008,830603,632856,530099,105584,389378,1020532,636999,944395,989250,366923,704302,842140,517497,67494,175319,24723,135779,14189,342834,249969,191195,196474,174370,444854,207537,695018,440881,475081,966305,337505,529595,766738,49274,37766,160176,300060,899771,444762,908909,792207,611159,655649,235098,684886,864836,809673,330013,79900,246592,187594,439242,1026561,22903,861630) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004763s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 497601 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 497601 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000490s ]