SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001314s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 806099 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 806099 [ RunTime:0.001589s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1016502,784754,1047280,138907,217014,169926,480891,153543,680994,510309,58764,507223,429140,505691,518006,810969,968350,205239,291001,766868,692225,886592,741551,115112,88414,746598,663274,901414,804330,286816,437943,1012901,225358,451921,534988,434136,437559,148964,103671,746174,887653,534800,162335,535648,776023,364478,405020,534077,458357,637742,321471,7666,249155,854363,760277,943932,900067,991810,217136,703865) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000992s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 806099 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 806099 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000609s ]