SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002811s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414748 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414748 [ RunTime:0.001652s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (117649,847586,641328,459132,544637,8888,941982,845944,1003302,522764,965134,856090,836194,140808,906438,295534,1030310,702675,813949,436065,288099,833885,961412,902666,934232,300045,973670,264093,614215,987234,744790,354091,899285,1001303,478238,1033741,299450,492447,307542,608985,787198,759796,786456,467230,355676,51211,770491,1025223,501063,24387,575510,29421,980716,717096,980026,960717,267535,392879,362777,651845) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001050s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414748 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414748 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000524s ]