SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001285s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 391308 LIMIT 1 [ RunTime:0.000317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 391308 [ RunTime:0.001669s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1022559,230288,448173,524776,8978,139612,818175,918156,532210,769158,846046,417776,948828,100843,802669,48498,433436,688747,729337,886482,562244,838732,581306,432516,272558,915827,208251,342222,494592,957854,675904,101710,209455,172214,682245,548640,110707,852066,792434,1040617,83396,315001,645647,586118,301244,431173,218432,33205,480068,400684,991137,367847,14633,934174,367050,157543,61081,524024,378719,338949) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001655s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 391308 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000423s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 391308 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000382s ]