SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003056s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 383879 LIMIT 1 [ RunTime:0.002914s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 383879 [ RunTime:0.002299s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (355236,537439,587656,128376,626065,492218,292721,448173,458294,69640,285308,45258,311079,184826,895163,228307,39407,989335,559240,128424,283168,986159,677962,108848,85691,338231,211848,162501,1035992,816809,706726,313368,945737,877130,830380,555991,396313,18454,1025919,386900,561142,718816,417502,566383,481644,587600,162923,319187,157921,317248,102174,850743,790231,309265,586472,352544,634594,641179,85268,670552) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 383879 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 383879 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000430s ]