SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001314s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 46725 LIMIT 1 [ RunTime:0.000494s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 46725 [ RunTime:0.002304s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (50686,1032018,522795,948873,755438,802559,330341,592766,1005484,820550,1003764,681715,389479,162491,863986,252994,1023990,1028488,624433,756359,642122,281973,504689,226104,410154,1000479,943459,277908,525685,304988,222670,987522,213394,231499,659181,138074,564077,1013908,222145,76442,221406,1037204,995500,965611,89394,293588,792386,812882,613580,624651,599036,867365,417601,432066,235591,416832,483304,157855,511488,497445) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.008606s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 46725 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 46725 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001005s ]