SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002346s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 577407 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 577407 [ RunTime:0.002738s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (37099,847780,724472,309126,659967,123485,794371,705661,687371,554927,386723,371347,892203,1021463,436788,736304,405689,154720,83844,620316,508467,241790,21657,724373,602992,43993,762849,188617,368502,139368,551231,1022933,818779,845791,941915,57914,263840,96153,200828,38416,204968,646842,577766,83664,920958,357636,828746,571312,369203,582656,408039,627810,251989,816694,891653,758792,797556,1024879,34618,154049) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 577407 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000588s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 577407 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000647s ]