SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003548s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503298 LIMIT 1 [ RunTime:0.001342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503298 [ RunTime:0.003403s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (874501,983634,483646,318005,778497,20748,212140,824984,110255,515191,737915,706110,462241,352002,783885,538342,852898,659573,205960,44641,407938,310292,844967,710154,485458,39552,102870,149243,588127,584494,764926,525198,737573,454279,990061,506689,74389,727562,271456,997224,1022058,743328,543050,844722,703725,493035,865103,442688,1029627,41991,880980,648769,135047,698309,806440,441128,940699,875829,1035041,265277) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002636s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503298 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503298 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000564s ]