SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 578014 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 578014 [ RunTime:0.001778s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (197096,760591,708408,186013,1031490,258012,503339,867662,616617,244864,846814,380764,601397,300950,697290,480469,323551,909512,613030,60109,124152,163204,17578,665849,294048,431732,77240,856787,249554,507807,403645,658065,800315,791726,416393,150644,122667,941471,881066,158869,940058,489222,137388,843517,728884,513107,754046,120553,151854,708560,836525,520184,752629,450117,593409,524231,292840,871567,594641,842291) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001026s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 578014 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 578014 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000997s ]