SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 421106 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 421106 [ RunTime:0.001544s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (455431,582496,484589,717725,557030,281359,418668,504429,692072,446605,739880,681850,669181,47524,481462,1033222,804927,359967,964215,621226,604449,867471,140612,276410,444690,789117,657311,47041,407425,302888,941892,270360,308294,519047,632725,600704,171768,36273,6496,522536,153670,154562,981475,973873,892650,277444,1000365,958069,532934,30408,518346,501548,821946,514639,970548,508489,462701,931915,598995,345634) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001590s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 421106 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 421106 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000592s ]