SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 498812 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 498812 [ RunTime:0.002049s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (567359,296161,404574,801164,665964,210967,452286,532446,998802,105870,262793,111685,189078,90536,119352,509029,148908,93250,617039,691000,818461,384385,793509,761048,601749,167450,164552,805807,960688,422968,830261,969128,930383,32241,669446,832783,989297,931498,155252,492260,948571,815345,937780,860578,165203,248515,776439,103000,13843,338076,24796,8348,492817,810982,150924,1014807,953566,172436,402534,743790) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001467s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 498812 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000450s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 498812 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000607s ]