SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541616 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541616 [ RunTime:0.002845s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (111988,293505,550402,885780,887754,410044,70730,522151,148399,153610,101276,120220,263190,791232,771455,901544,443328,126970,269533,923527,504115,825083,1047622,556448,323206,524473,624697,889479,998403,397294,216029,453941,440162,765970,822509,993761,54086,549585,19349,334278,766932,828583,142639,218567,785885,651975,1003581,959902,814905,584237,149263,554589,118570,306253,195110,219857,252357,938613,662589,604527) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001111s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541616 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541616 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000590s ]