SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001252s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401339 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401339 [ RunTime:0.004464s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (55124,167982,669996,48949,932313,302734,620099,59739,291435,834804,142047,276020,488345,584023,486162,695518,702672,439140,211297,126006,669910,862366,943498,852488,603252,822462,327432,647865,274433,199800,141973,187568,459795,862630,860626,909827,760702,231077,894699,999382,390280,662871,818746,605327,441789,294072,985379,265677,342388,794984,156716,579601,835265,709574,435320,976241,949886,975440,698859,283552) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001806s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401339 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401339 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]