SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 175215 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 175215 [ RunTime:0.001835s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (48889,829844,654427,44985,866881,149103,13216,674522,256770,892566,275937,60496,398998,919814,167630,188545,916046,1009848,994210,679433,733409,118954,967114,317448,481634,503227,997317,628362,516447,340333,470605,630568,640994,216805,46647,762842,825605,775231,451821,515985,871335,1046317,734765,401452,281602,815511,961014,609777,488546,1022422,330377,64453,450728,1042361,314372,938271,358152,118836,722744,54611) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 175215 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 175215 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002461s ]