SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 424093 LIMIT 1 [ RunTime:0.000434s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 424093 [ RunTime:0.001698s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (285455,1031980,823233,750090,183889,78985,612814,859664,237562,508743,668115,494966,868145,217423,113813,218489,142491,764368,915864,494764,88790,303598,356923,886603,732599,537693,311704,944370,801746,602726,84069,982025,311577,811111,399661,695957,80328,440038,413349,669988,117026,996854,323532,288676,625619,26166,262598,834964,1048359,114748,158237,649617,829065,477027,165837,489131,819330,675704,340083,553998) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001255s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 424093 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 424093 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]