SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1032199 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1032199 [ RunTime:0.001792s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (552088,404841,451089,1041617,336274,593688,454548,533414,248623,742536,794104,783920,223665,614927,857328,502202,75379,410234,200716,536570,566099,1003508,76034,613875,675922,292693,902599,932115,788800,675450,176488,578759,790947,59181,739004,862375,131951,479871,373335,305763,966626,903076,469780,513984,532402,864719,383175,290385,546244,671545,582643,107037,480296,824769,774872,565212,500019,819815,201262,806143) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001268s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1032199 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1032199 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]