SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 65494 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 65494 [ RunTime:0.003604s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (250271,401499,496848,491890,907371,137696,114297,677837,142533,20468,588590,764018,629414,394002,855958,883757,453833,817633,185274,547425,261276,382594,183525,629984,412814,531061,173954,159298,415999,1030163,955241,947333,577983,738553,258030,372366,491283,89465,342013,410938,154897,74845,16232,465305,563217,147138,8150,989879,160443,924635,530418,733278,413248,868634,440749,157973,855599,1036076,516144,109280) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001029s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 65494 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000579s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 65494 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]