SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001376s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 199513 LIMIT 1 [ RunTime:0.000476s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 199513 [ RunTime:0.002475s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (273576,426565,234041,440543,470556,144750,923440,704217,114431,459228,110444,881984,661804,470806,82405,281963,111571,524739,334980,1011130,1025069,812339,939560,1000878,548460,799889,602999,793422,19820,919123,142341,87827,838191,718024,437480,235494,475355,934373,435526,332649,157796,535820,657145,874855,93411,831832,599376,74129,1007168,276411,863730,552507,475760,472945,312072,606747,245744,677758,500000,805895) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 199513 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 199513 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000489s ]