SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 867482 LIMIT 1 [ RunTime:0.000285s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 867482 [ RunTime:0.001816s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1039175,1017194,405678,754834,799303,328026,200890,389351,440173,195937,810736,128407,556855,568379,887193,374241,199161,966373,346713,945804,891359,364919,568184,974774,210278,275285,675537,830055,346422,460400,192125,803467,1040687,484556,19458,830573,485846,742968,306078,1020284,14151,56963,387929,225194,251572,618983,268972,892601,961336,857681,183327,685099,529528,999277,7547,734495,163366,718062,493430,796551) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001028s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 867482 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 867482 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]