SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 320896 LIMIT 1 [ RunTime:0.000559s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 320896 [ RunTime:0.001849s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (526482,690429,867290,960059,638810,447410,299163,664540,291448,862126,948285,793266,762543,119502,653492,96854,951044,307162,914043,771788,317786,288532,737439,542602,530016,103180,436778,130925,983347,1040337,176803,673235,52775,611723,1001312,509441,558636,568063,430409,126109,559195,753216,605623,565474,301984,302423,111924,783521,750961,1047461,954058,142828,628316,371277,54073,891828,829086,481502,335104,7221) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001023s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 320896 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 320896 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000500s ]