SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 480398 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 480398 [ RunTime:0.001555s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (417240,357523,244121,937577,158888,570677,795133,180145,884326,851457,582376,110500,195010,668999,471060,204899,810332,90180,555062,828351,926883,645585,836485,351876,890749,759248,1977,377858,979508,785681,811721,34432,362508,960472,44920,254906,883440,597015,937614,515816,287256,496601,257601,824599,544208,63484,755063,867040,706585,583976,379187,234446,576333,520678,109529,103252,411139,993832,905601,725987) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001038s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 480398 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 480398 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000485s ]