SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001646s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 826844 LIMIT 1 [ RunTime:0.001360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 826844 [ RunTime:0.000985s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (533326,338892,997446,568358,604298,152414,289132,574472,974306,174135,93311,848453,762436,536320,724460,1000540,158876,146222,976870,518196,574128,1046851,782763,205646,398019,334234,170076,612381,657749,1009279,541702,195864,367357,492633,629818,269711,754165,400076,654668,895173,664963,103293,385749,159169,95415,962113,960886,40136,265975,173030,277158,834120,753805,545397,993977,227038,242634,920200,764313,1024328) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000985s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 826844 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 826844 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000451s ]