SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002637s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 553796 LIMIT 1 [ RunTime:0.001672s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 553796 [ RunTime:0.002692s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1027341,166923,785915,230952,997968,463080,446813,376862,892794,166823,120414,414521,486390,285153,585851,635301,806032,894195,815595,573415,555515,410976,112777,174104,840032,105545,791604,957722,654918,251175,825132,981998,382116,76754,519197,391340,638446,933061,405128,743831,926679,255876,737753,414500,868354,862706,573784,122176,285707,672080,1009894,259430,636337,447712,829396,586170,617781,711742,847161,1017303) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 553796 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000531s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 553796 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000507s ]