SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 293517 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 293517 [ RunTime:0.001614s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (111663,313162,333993,555759,296606,207392,715197,899105,975618,625801,455699,900624,248861,623433,97390,356215,130701,270880,924741,772750,536794,549356,236035,844589,685280,622913,805054,11300,465433,480914,760933,994340,644565,214579,80300,627057,162746,344874,77947,204990,663205,629483,552713,162949,923901,992259,953814,1019690,253121,212154,40014,901013,206566,707399,688241,654433,4650,993447,467963,540980) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000963s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 293517 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000310s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 293517 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000502s ]