SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001576s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 439451 LIMIT 1 [ RunTime:0.000407s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 439451 [ RunTime:0.001678s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1015532,977986,252387,510324,631939,953984,614558,916297,111053,857054,116831,309363,556191,784208,986884,346238,282477,561282,687711,329858,796977,222789,84592,869545,747777,91241,229604,13023,941663,758921,484000,487477,10445,575643,176417,150826,659258,294738,831689,74322,526995,619860,983130,254495,259265,187786,414957,154637,351513,177494,881706,556300,524306,922729,568239,480411,1016865,74598,522824,287980) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001011s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 439451 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 439451 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000682s ]