SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1036158 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1036158 [ RunTime:0.001511s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (526493,1030630,305903,405836,36906,84393,805539,776061,961074,548029,487375,797297,551867,92566,945203,823274,753265,754639,7554,407043,993602,823940,3518,462308,508224,857694,338229,356832,861678,863711,862203,653768,56467,534055,481787,635130,143249,141695,990287,246060,909810,713510,181258,193817,612788,269600,346269,961024,353809,416629,740848,991257,777253,125153,550638,942178,37273,758247,702041,463230) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001005s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1036158 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1036158 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000665s ]