SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 347098 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 347098 [ RunTime:0.002059s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (701017,496192,626489,823941,371682,924752,84058,291358,630941,566268,196021,561280,636512,625366,651491,56248,334024,1038240,536537,458459,863954,1016120,121880,900725,279256,279386,320313,242889,16784,877353,1029475,529713,77337,1021825,713839,458231,75261,274558,497662,701556,541282,741034,77390,809276,611720,474383,557028,636318,780366,635486,698148,311073,963836,848941,779465,562981,294248,214760,351918,297438) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001027s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 347098 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 347098 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000409s ]