SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501438 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501438 [ RunTime:0.001751s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (9696,827856,941096,420372,791367,599884,349548,926939,133435,126406,184567,1029339,546573,141362,153729,48144,233740,74598,1010126,925618,909158,757615,742127,1012763,57437,76500,996506,983734,935177,798556,248887,981591,454452,845870,611903,228261,600586,576517,411371,976339,600582,699595,839434,360223,342177,136433,154083,760271,133937,962638,1033265,109293,708434,806350,912763,629314,44304,988653,269112,800608) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501438 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004443s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501438 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000534s ]