SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001498s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 804159 LIMIT 1 [ RunTime:0.000504s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 804159 [ RunTime:0.004798s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (120295,220012,935889,899301,833674,956787,338283,774552,561665,632149,79092,851854,1038430,588202,457439,952379,163866,37151,335923,740710,429313,1020426,435902,281473,813206,100802,261393,934706,135349,522181,321513,774558,554581,762680,235520,472953,380236,440708,175447,227125,692208,138724,447662,218856,1014232,286001,579222,406835,222258,875969,352581,136573,107622,5960,766129,337280,587872,905463,164617,171661) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001021s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 804159 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 804159 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000401s ]